sokwe.janegoodall.org Git - kop

3 days ago	Karl O. Pinc...	Validate PANTGRUNS.EnteredBy against PEOPLE.Active master	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Validate LOCATIONS_B.EnteredBy against PEOPLE.Active	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Validate GROOMINGS.ExtractedBy against PEOPLE.Active	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Validate GROOM_SCANS_B.ExtractedBy against PEOPLE.Active	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Validate COMM_MEMB_LOG.MadeBy against PEOPLE.Active	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Fire comm_memb_log_trigger after INSERT as well as...	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Validate BIOGRAPHY_LOG.MadeBy against PEOPLE.Active	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Fire biography_log_trigger after INSERT as well as...	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Validate ARRIVALS_A.Recorder and Observer2 against...	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Validate AGGRESSIONS.ExtractedBy against PEOPLE.Active	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	Remove dead code	commit \| commitdiff \| tree \| snapshot
3 days ago	Karl O. Pinc...	ARRIVALS_A has no column called DataSource	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Create, document, index, and trigger PANTGRUNTS	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Add PANTGRUNTS.Source column	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Create PG_SOURCES code table	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Get rid of unneeded key columns	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Produce a consistent error message	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Fix hyperlink targets	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Change Community to CommID on PANTGRUNTS diagram	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Remove PANTGRUNTS.Mutual column	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Create, document, index, and trigger LOCATIONS_B	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Fix so null_xor_null() macro can be used on dispariate...	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Change function and trigger names to reflect that they...	commit \| commitdiff \| tree \| snapshot
4 days ago	Karl O. Pinc...	Create LOCATION_ORIGINS support table	commit \| commitdiff \| tree \| snapshot
5 days ago	Karl O. Pinc...	Fix section underlineing	commit \| commitdiff \| tree \| snapshot
5 days ago	Karl O. Pinc...	New sdb_null_xor_null() macro, when one colum or anothe...	commit \| commitdiff \| tree \| snapshot
5 days ago	Karl O. Pinc...	Adjust text to read better when incorporated into a...	commit \| commitdiff \| tree \| snapshot
6 days ago	Karl O. Pinc...	Fix SWELLING_STATES diagram to reflect db	commit \| commitdiff \| tree \| snapshot
6 days ago	Karl O. Pinc...	Fix SWELLING_SOURCES diagram to reflect db	commit \| commitdiff \| tree \| snapshot
6 days ago	Karl O. Pinc...	Fix REPRO_STATES diagram to reflect db	commit \| commitdiff \| tree \| snapshot
6 days ago	Karl O. Pinc...	Create, document, index, and trigger REPRO_STATES	commit \| commitdiff \| tree \| snapshot
6 days ago	Karl O. Pinc...	Fix animid_column() macro so column cannot be NULL	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Use eid_primary_key() macro	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Correctly invoke animid_column() macro	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Invoke animid_column() macro with parenthesis	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Alphabetize by table name	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Create REPRO_STATE_CHANGE_SOURCES code table	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Create PARITIES code table	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Create LE_CERTAINTIES code table	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Create ED_CERTAINTIES code table	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Correct copyright date	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Remove the ARRIVALS_A.ArAID column and use EID as the...	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Index and trigger SPECIES_PRESENT	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Fix hyperlinks	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Remove the SPECIES_PRESENT.OSID column and use EID...	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	EVENTS with Behavior = sdb_other_species cannot be...	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	sdb_other_species events must be "certain"	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	sdb_other_species events must have a related FOLLOWS row	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Write triggers for HUMANS	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Document the sdb_other_species event type's validation...	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Fix hyperlink	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Remove the HUMANS.HuID column and use EID as the primar...	commit \| commitdiff \| tree \| snapshot
7 days ago	Karl O. Pinc...	Remove the GROOM_SCANS_B.GsID column and use EID as...	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Remove GROOMINGS.GrID and use EID as the primary key	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Remove FOOD_EVENTS.FEID and use EID as the primary key	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Remove AGGRESSIONS.AgID and use EID as the primary key	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Add triggers for SWELLING_SOURCES	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Correct "ATTENDANCE after under study" error message	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Fix inequality that broke ATTENDANCE under-study check	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Spelling	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	A shorter and more clear error message	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Index the swelling sources on SWELLING_STATES	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	New build_arrivals_seq() function, in case the auto...	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Automatically maintain ARRIVALS.Seq	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Clarify ARRIVALS.Seq ordering in the docs	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Require an ARRIVALS row have a related ROLES row	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	Remove ARRIVALS.ArID and use EID as the primary key	commit \| commitdiff \| tree \| snapshot
8 days ago	Karl O. Pinc...	New table macro eid_primary_key()	commit \| commitdiff \| tree \| snapshot
9 days ago	Karl O. Pinc...	Fix and use correct key column name	commit \| commitdiff \| tree \| snapshot
9 days ago	Karl O. Pinc...	Remove accidental leftover graphic elements	commit \| commitdiff \| tree \| snapshot
9 days ago	Karl O. Pinc...	Simplify because events only fire on update	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Support groom scanning at the feeding station as an...	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Create, document, index, and trigger ARRIVALS_A	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Remove arrival related information from ATTENDANCE	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Fix check for unique roles per event	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Update roles docs to note that roles apply to feeding...	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Update diagrams for event based attendance design	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Grammer	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Use macro to enforce Certainty = sdb_identity_certain	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Use macro to enforce Start = Stop	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Shorten EVENTS.Behavior constraint name to fit within...	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Allow the EVENT.Behavior to be sdb_groom_scan	commit \| commitdiff \| tree \| snapshot
12 days ago	Karl O. Pinc...	Give time precision docs their own section	commit \| commitdiff \| tree \| snapshot
13 days ago	Karl O. Pinc...	Hyperlink to tables that have been documented	commit \| commitdiff \| tree \| snapshot
13 days ago	Karl O. Pinc...	Move docs of sdb_actor, sdb_actee, and sdb_mutual into...	commit \| commitdiff \| tree \| snapshot
13 days ago	Karl O. Pinc...	Update copyright date	commit \| commitdiff \| tree \| snapshot
13 days ago	Karl O. Pinc...	Grammar	commit \| commitdiff \| tree \| snapshot
13 days ago	Karl O. Pinc...	Make sdb_mutual (Mutual) a special ROLE_CODES.Role...	commit \| commitdiff \| tree \| snapshot
2026-05-29	Karl O. Pinc...	Allow EVENTS and ATTENDANCE to relate, add EVENTS.AtID...	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	New null_xor_null() macro: exactly one of 2 columns...	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	EVENTS is to reference ATTENDANCE, so create ATTENDANCE...	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	Convert the follow_map_time_problems table into the...	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	With groom scans, start must equal stop	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	Change table name GROOM_SCANS -> GROOM_SCANS_B	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	Replace "estrus" with "swelling", FEMALE_STATES ->...	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	Change "estrus" to "swelling" in ESTRUS_STATES names	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	Talk about "swelling" not "estrus" in the CYCLE_STATES...	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	Change global constant name sdb_manual_estrus -> sdb_ma...	commit \| commitdiff \| tree \| snapshot
2026-05-28	Karl O. Pinc...	Change "estrus" to "swelling" in ESTRUS_SOURCES names	commit \| commitdiff \| tree \| snapshot
2026-05-27	Karl O. Pinc...	Fix so FOLLOWS.CommID is validated against COMM_IDS	commit \| commitdiff \| tree \| snapshot
next

Karl O. Pinc's public repository for SokweDB development

RSS Atom